You can use Stored Procedures in combination with all sorts of things to create dynamic, powerful web pages.
This page uses no ASP itself, but contains 2 forms; Each sends data to a different ASP.NET page.